Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

Oracle PLSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) Character String Functions
4) Collections
5) Conversion Functions
6) Cursor
7) Date Timestamp Functions
8) Function Procedure Packages
9) Index
10) Insert Update Delete
11) Introduction
12) Large Objects
13) Linear Regression Functions
14) Miscellaneous Functions
15) Numerical Math Functions
16) Object Oriented
17) PL SQL Data Types
18) PL SQL Operators
19) PL SQL Programming
20) PL SQL Statements
21) Query Select
22) Regular Expressions Functions
23) Sequences
24) Set
25) SQL Data Types
26) SQL PLUS Session Environment
27) Statistical Functions
28) System Packages
29) System Tables Data Dictionary
30) Table
31) Table Joins
32) Transaction
33) Trigger
34) User Privilege
35) View
36) XML

Table Joins
1) Adding Ordering to a Joined Result
2) Adding Ordering to the Query Containing the GROUP BY
3) An Example of a Left Outer Join 1
4) An Example of a Left Outer Join 2
5) An Example of a Right Outer Join 1
6) An Example of a Right Outer Join 2
7) Autotrace ansi full outer join
8) Calculation between column from different tables
9) Cartesian Products
10) Convert subqueries to JOINs
11) Example equijoins
12) Example outer join with (+)
13) Example simple join
14) Inner and Outer Joins
15) Inner and Outer Joins(room and class)
16) Join table using
17) Join tables and order by columns from different tables
18) Join two tables and combine three tables
19) Left and Right Outer Joins
20) LEFT OUTER JOIN tableName ON joined columns
21) LEFT OUTER JOIN vs RIGHT OUTER JOIN
22) Left Outer Join
23) Limitations on Outer Joins
24) List table from two tables and specifying its column owner
25) List table from two tables without indicating column owner
26) Natural join two tables
27) Perform outer joins in combination with self joins
28) Perform outer joins in combination with self joins, employee and job tables
29) Performing Cross Joins Using SQL92
30) Performing Full Outer Joins Using SQL92
31) Performing Inner Joins on Multiple Columns Using SQL92
32) Performing Inner Joins on Two Tables Using SQL92
33) Performing Inner Joins on Two Tables Using SQL92, on clause
34) Performing Joins Using the SQL92 Syntax
35) Performing Left Outer Joins Using SQL92
36) Performing Outer Joins Using SQL92
37) Performing Right Outer Joins Using SQL92
38) Performing SELECT Statements that Use More than Two Tables
39) Performing SELECT Statements that Use Two Tables
40) Performing Self Joins Using SQL92
41) Reference column without table name during table join
42) Right join with where in clause
43) Right Outer Join
44) Right outer join with group by
45) Right outer join with using statement
46) Right Outer Join(room vs class)
47) Self join a table
48) Simplifying Joins with the USING Keyword
49) Supplying Table Aliases
50) The Order with GROUP BY
51) Three different types of joins
52) Understanding Non-equijoins
53) Understanding Outer Joins
54) Understanding Self Joins
55) Use in non-equality join
56) Use in non-equality table join
57) Use table alias in table join
58) Use to reference all columns from a table
59) Using clause for table join
60) Using Inner Joins
61) Using two columns during table join
62) You cannot use an outer join condition with another join using the OR operator
63) You cannot use an outer join condition with the IN operator